Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2273

R_2273

PhStDocType

PhStDoc

StDocTypeID

 

 

R_2277

R_2277

PhStDoc

PhStDocItem

StDocID

 

 

R_2278

R_2278

PhLot

PhStDocItem

LotID

 

 

R_2279

R_2279

PhStDocKind

PhStDocKindText

StDocKindID

 

 

R_2280

R_2280

PhStDocStatus

PhStDocStatusText

StDocStatusID

 

 

R_2281

R_2281

PhStDocMetaType

PhStDocType

StDocMetaTypeID

 

 

R_2282

R_2282

PhStDocType

PhStDocTypeText

StDocTypeID

 

 

R_2284

R_2284

PhResource

PhStItem

ResourceID

 

 

R_2285

R_2285

PhPack

PhStItem

PackID

 

 

R_2286

R_2286

PhDrugClass

PhDrugClassText

DrugClassID

 

 

R_2287

R_2287

PhStItem

PhStItemGroupAssoc

StItemID

 

 

R_2288

R_2288

PhStItemGroup

PhStItemGroupAssoc

StItemGroupID

 

 

R_2289

R_2289

PhStItemGroup

PhStItemGroupText

StItemGroupID

 

 

R_2290

R_2290

PhStItem

PhStItemReserve

StItemID

 

 

R_2291

R_2291

PhSt

PhStItemReserve

StID

 

 

R_2292

R_2292

PhStOrderType

PhStOrder

StOrderTypeID

 

 

R_2295

R_2295

PhStOrderStatus

PhStOrder

StOrderStatusID

 

 

R_2296

R_2296

PhStOrderItemStatus

PhStOrderItem

StOrderItemStatusID

 

 

R_2298

R_2298

PhStOrder

PhStOrderItem

StOrderID

 

 

R_2299

R_2299

PhResource

PhStOrderItem

ResourceID

 

 

R_2300

R_2300

PhStOrderItemStatus

PhStOrderItemStatusText

StOrderItemStatusID

 

 

R_2301

R_2301

PhStOrderStatus

PhStOrderStatusText

StOrderStatusID

 

 

R_2302

R_2302

PhStOrderType

PhStOrderTypeText

StOrderTypeID

 

 

R_2305

R_2305

PhStType

PhStTypeText

StTypeID

 

 

R_2306

R_2306

PhCoreSubst

PhSubst

CoreSubstID

 

 

R_2307

R_2307

PhCpv

PhTenderList

CpvID

 

 

R_2309

R_2309

PhResource

PhTenderListItem

ResourceID

 

 

R_2310

R_2310

PhTenderList

PhTenderListItem

TenderListID

 

 

R_2311

R_2311

PhPack

PhTenderListItem

PackID

 

 

R_2313

R_2313

PhTenderList

PhTenderOffer

TenderListID

 

 

R_2316

R_2316

PhTenderOffer

PhTenderOfferItem

TenderOfferID

 

 

R_2317

R_2317

PhTenderListItem

PhTenderOfferItem

TenderListItemID

 

 

R_2318

R_2318

PhTenderType

PhTenderTypeText

TenderTypeID

 

 

R_2319

R_2319

PhTradeDocStatus

PhTradeDoc

TradeDocStatusID

 

 

R_2320

R_2320

PhStDoc

PhTradeDoc

StDocID

 

 

R_2323

R_2323

PhTradeDocType

PhTradeDoc

TradeDocTypeID

 

 

R_2324

R_2324

PhTradeDoc

PhTradeDocItem

TradeDocID

 

 

R_2325

R_2325

PhTradeDocStatus

PhTradeDocStatusText

TradeDocStatusID

 

 

R_2326

R_2326

PhTradeDocType

PhTradeDocTypeText

TradeDocTypeID

 

 

R_2327

R_2327

PhUnitType

PhUnit

UnitTypeID

 

 

R_2328

R_2328

PhUnitType

PhUnitTypeText

UnitTypeID

 

 

R_2329

R_2329

PhSt

PhStLimit

StID

 

 

R_2340

R_2340

PhResource

PhLResourceResource

ResourceID

 

 

R_2342

R_2342

PhDrugClass

PhDrug

DrugClassID

 

 

R_2350

R_2350

PhReservationStatus

PhReservationStatusText

ReservationStatusID

 

 

R_2360

R_2360

PhStItem

PhLTendOffItemStItem

StItemID

 

 

R_2361

R_2361

PhTenderOfferItem

PhLTendOffItemStItem

TenderOfferItemID

 

 

R_2362

R_2362

PhTenderOfferItem

PhTradeDocItem

TenderOfferItemID

 

 

R_2363

R_2363

PhAddress

PhCompany

AddressID

 

 

R_2370

R_2370

PhStOrderItemChange

PhStOrderItemChangeText

StOrderItemChangeID

 

 


1  2  3  4  5  6  7  8